To automatically adjust the column width based on the contents of the cell with the largest amount of data, do one of the following:

•Hover the mouse cursor over the right border of the column header so that the cursor takes the form of a two-sided arrow, and double-click.

•Right-click on the column header and execute the context menu command Fit width to content.

•Right-click on the column header and execute the context menu command Column width. In the Column width window, select Adjust automatically and click OK.

To automatically adjust the row height based on the contents of the cell with the largest amount of data, do one of the following:

•Hover the mouse cursor over the lower border of the header so that the cursor takes the form of a two-way arrow, and double-click.

•Right-click on the line header and execute the context menu command Fit height to content.

•Right-click on the line header and execute the context menu command Row height. In the Row height window, select Adjust automatically and click OK.

To automatically adjust the width/height of several columns/rows, follow these steps:

1.Select the required columns/rows.

2.Autofit width/height in one of the following ways:

•Hover the mouse cursor over the border between any two column/row headers in the selected range so that the cursor takes the form of a two-sided arrow. Double-click.

•Right-click on the header of any column/row in the selected range and execute the context menu command Fit width to content or Fit height to content.

•Right-click on the header of any column/row in the selected range and execute the context menu command Column width or Row height. In the window that opens window, select Adjust automatically and click OK.

For each column/row in the selected range, the width/height will be selected according to the contents of the cell with the largest amount of data.